Drug Movement Report
The Drug Movement Report provides gross profit data for all drugs dispensed during the report period. The report also displays Gross Profit Totals for the dispensed drugs.
This report does not include prescriptions filled for mixtures, or Fee for Service prescriptions, therefore it is not a representation of overall profit for the period - mixtures are reflected on the Mixture Movement report. Fee for Service prescriptions, including Refusal to Fill prescriptions in British Columbia, are not included in the report since no medication has been dispensed for these types of prescriptions.
This report does not include pre-authorized prescriptions. The report only includes prescriptions with a status of either Complete or Amend that have a fill date that falls within the report period. Pre-authorized prescriptions are included once they are authorized and will appear on the report for the date the prescription was filled (not the date it was authorized).
Sample Report
Click on an area in the sample report to see a description of the field.
Non-retail prescriptions with the following group Rx statuses are included in the report:
- A - Active Regular Dose
- C - First Fill Print Only External
- D - Daily (for Monthly NH Only)
- I - Inactivate Regular
- O - Active Non-Drug
- P - First Fill Print Only
- W - Active PRN Dose
- X - Active External
- Z - Adjudicate to $0.00 ['Z' prescriptions have $0.00 pricing and $0.00 gross profit]
As well as displaying data for all prescriptions dispensed during the report period, the report can be generated for a specific patient, doctor, drug, third party, group, manufacturer, supplier, custom class and/or therapeutic class. When one or more of these criteria are specified, it will be indicated near the top of the report.
When a third party is requested in the report criteria, the report will only include data from prescriptions that used the specified third party as the PRIMARY third party in the billing code.
Example
A pharmacist wants to see all prescriptions that were submitted to Assure (AS) during the report period. The report will include data from prescriptions where AS is the primary third party in the billing code, therefore it will include prescriptions with billing codes such as AS/CA and AS/EP/CA. The report will not include prescriptions with billing codes such as EP/AS/CA.
Extended Report Criteria
There are several options available in the Extended report criteria:
- Maximum # of Drugs to Include: Allows a maximum number of drugs to be specified. The selected sort option is used to determine which drugs are to be included on the report. When a maximum number of drugs is specified, a # of Drugs field will appear near the top of the report, indicating the number of drugs included. (Example: A pharmacist wants to see 50 drugs with the highest Rx Volume during the report period. The pharmacist will enter 50 in the Maximum # of Drugs to Include field and will sort the report by Rx Volume. Only the first 50 drugs will be listed on the report.)
- Enterprise: Selecting the Enterprise flag (DT banners) only includes primary and secondary selections on the report. When the report is generated for Enterprise, it is indicated at the top of the report.
- POS Products: When this flag is selected, the report only includes drugs that are flagged as POS Products in the Inventory tab of the Drug folder. This provides the ability to determine usage and gross profit for front shop products dispensed in prescriptions. When the report is generated for POS Products, it is indicated at the top of the report.
- OTC: When this flag is selected, the report only includes drugs that are flagged as OTC in the main tab of the Drug folder. This provides the ability to determine usage and gross profit for OTCs dispensed in prescriptions. When the report is generated for OTCs, it is indicated at the top of the report.
- Create for: The options listed under Create For allow the report to be generated for all drugs that fall under the selected category: non-narcotics or for specific types of narcotics (all narcotics, reportable narcotics or non-reportable narcotics). The selected option is indicated near the upper right side of the report. Only one of these options can be selected. By default, the report is generated for All Drugs. To include all drugs in the report, All Drugs should be selected in the extended report criteria. This means all drugs belonging to the specific category will be included in the report. For example, if the report is generated for a specific custom class, All Drugs includes all of the drugs that belong to the custom class.
- Selecting Non-Narcotics only includes regular drugs in the report; narcotics will be excluded. For example, if the report is generated for a specific custom class, Non-Narcotics includes all regular (non-narcotic) drugs that belong to the custom class.
- There are three options for generating the report for narcotics. To begin with, the Narcotics option must be selected. Then select an option from the dropdown list. All Narcotics means the report will include all narcotics; this is the default setting when the Narcotics option is selected. Non-Reportable means the report will only include non-reportable narcotics. Reportable means the report will only include for reportable narcotics.
- Drug Schedule: The options listed under Drug Schedule allow the report to be generated for all drug schedules (and therefore all drugs), or for one or more drug schedules. By default, the report is generated for all drug schedules. The selected schedules are indicated near the top of the report. To include all drugs in the report, Include all Schedules should be selected in the extended report criteria. This means all drugs belonging to the specific category will be included in the report. For example, if the report is generated for a specific custom class, Include all Schedules includes all of the drugs that belong to the custom class.
- Selecting Only Include allows you to choose one or more drug schedules: Schedule I, Schedule II, Schedule III and/or Schedule IV. Select the schedule(s) for which the report should be generated. This provides usage and gross profit for drugs that have a specific drug schedule. For example, selecting Schedule IV creates the report for all Schedule IV drugs.